#region Using directives
using System;
using System.Data ;
using System.Collections;
using System.Collections.Specialized;
using WP.DB;
using WP.MF.DataEntity; 
using WP.Commons;
#endregion

namespace WP.MF.DataAccess
{
    public class MInterCompanyLocationDAL : IDataAccess
    {
        public MInterCompanyLocationDAL()
		{
		}

        #region Select List
        public string SQLList(int iParameter)
        {
            //LocationNo, InterCompanyAcctNo, InterCompanyProfitNo, InterCompanyBranchNo, InterCompFundTrfAcctNo, InterCompFundTrfProfitNo, InterCompFundTrfBranchNo, BankAcctNo, BankProfitNo, BankBranchNo
            string strSQL = @"SELECT RecId, CompanyName,CompanyDesc, ServerName, DatabaseName FROM mInterCompanyLocation order by CompanyName ";
            return strSQL;
        }
        #endregion

		#region Fields
		public string Fields
		{
			get
			{
                return @"CompanyName,CompanyDesc, ServerName, DatabaseName, LocationNo,InterCompanyFromAcctNo,InterCompanyFromProfitNo,InterCompanyFromBranchNo, InterCompanyAcctNo, InterCompanyProfitNo, InterCompanyBranchNo, 
                        InterCompFundTrfAcctNo, InterCompFundTrfProfitNo, InterCompFundTrfBranchNo, BankAcctNo, BankProfitNo, BankBranchNo,CombineQryOrRpt";
			}
		}
		#endregion
    }
}
